<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
  <meta charset="utf-8">
  <title>综合成绩管理</title>
  <meta name="renderer" content="webkit">
  <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
  <link rel="stylesheet" href="static/layui/css/layui.css" media="all">
  <link rel="stylesheet" href="static/layuiadmin/style/admin.css" media="all">
</head>
<body>
<!--templates/table/zhcjgl-->
<div class="layui-card layadmin-header">
  <div class="layui-breadcrumb" lay-filter="breadcrumb">
  </div>
</div>

<div class="layui-fluid">
  <div class="layui-row layui-col-space15">
    <div class="layui-col-md12">
      <div class="layui-card">
        <div class="layui-card-header card-title">综合成绩管理</div>
        <div class="layui-card-body">
          <form class="layui-form" lay-filter="component-form-group" id="search_submits" onsubmit="return false">
            <div class="layui-form layui-card-header layuiadmin-card-header-auto" lay-filter="layadmin-useradmin-formlist">
                <div class="layui-inline">
                    <span class="agileits_grid">
                        <label  style="margin-left: 47px;margin-right: 20px">学期<i>:</i></label>
                        <div class="layui-input-inline">
                           <select name="sid" id="sid"></select>
                        </div>
                    </span>
                </div>
              <div class="layui-inline">
                <label class="layui-form-label">学号：</label>
                <div class="layui-input-inline">
                  <input type="number" class="layui-input" id="name" name="name" placeholder="请输入学号"  width="80px">
                </div>
              </div>
              <div class="layui-inline">
                <button class="layui-btn" lay-submit="search_submits" lay-filter="reloadlst_submit">查询</button>
              </div>
              <div class="layui-inline">
                <a class="layui-btn btn-add btn-default" id="export">导出数据</a>
              </div>
            </div>
          </form>
          <table class="layui-hide" id="test-table-cellEdit" lay-filter="test-table-cellEdit"></table>
        </div>
      </div>
    </div>
  </div>
</div>

<script src="static/layui/layui.js"></script>
<script th:inline="none">
  layui.config({
    base: 'static/layuiadmin/' //静态资源所在路径
  }).extend({
    index: 'lib/index' //主入口模块
  }).use(['index', 'table','form'], function(){
    var $ = layui.$;
    var table = layui.table;
    var form = layui.form;
    var exportData;
    var loading = layer.load();
    var ins1 = table.render({
      elem: '#test-table-cellEdit'
      ,method:'post'
      , url: '/selectzhcjgl'
      , cols: [[
        {field: 'username', title: '学生姓名', width: 120, sort: true}
        ,{field: 'zxfjd', title: '总学分绩点', width: 180, sort: true}
        ,{field: 'zhcj', title: '综合成绩', width: 180, sort: true}
        ,{field: 'yscj', title: '原始成绩', width: 180, sort: true}
        ,{field: 'ztname', title: '目前状态', width: 180, sort: true}
        ,{field: 'xq', title: '学期', width: 180, sort: true}
      ]]
      , done: function (res, curr, count) {
        layer.close(loading);
        exportData = res.data;
      }
    })
      $("#export").click(function() {
        table.exportFile(ins1.config.id, exportData, 'xls');
      });
    form.on('submit(reloadlst_submit)', function (data) {
      var searchdata = data.field;
      var name = searchdata.name;
      var sid = $('#sid').val();
      ins1.reload({
        where:{
          name:name,
          sidstr:sid
        }
      });
    });
      $.ajax({
          url:"/selectxqxxgl",
          type:"post",
          dataType:"json",
          success: function (result) {
              var optionstring = "<option value='' style='display: none'>"+"请选择"+"</option>";
              for (var j = 0; j < result.count; j++) {
                  optionstring += "<option value='" + result.data[j].id + "'>" + result.data[j].year+"--"+result.data[j].xq + "</option>";
              }
              $("#sid").html(optionstring);
              form.render('select');
          },
          error:function (e) {
              layer.msg('服务器错误',{icon:2});
          }
      });
  });

</script>
</body>
</html>